Point of Sale Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HostID pWrkStnID 20      
Description pDescription 255      
LocID pLocID 10      
CustID pCustID 10      
SalesRepID pSalesRepID 3      
SalesRepRequired bit 1      
MaxDiscount pDecimal 13      
PmtMethodID nvarchar 10      
TaxGroupID pTaxLoc 10      
TransIDPrefix nvarchar 7      
DistCode pDistCode 6      
LayawayDays smallint 2      
UseSpooler bit 1      
DeviceName nvarchar 255      
PrinterName nvarchar 255      
CashDrawerCode nvarchar 255      
ReceiptHeader nvarchar max      
ReceiptFooter nvarchar max      
MenuMessage nvarchar max      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
CountID bigint 8      
CountGroup datetime 8      
CountType tinyint 1   Count Type 0 = Opening, 1 = Intermediate, 2 = Closing
UserID bigint 8      
TenderID bigint 8      
Quantity int 4      
Value pDecimal 13      
CurrencyID pCurrency 6      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
CountID bigint 8      
CurrencyID pCurrency 6      
Rate pDecimal 13      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HostID pWrkStnID 20      
TransDate datetime 8      
ClosingDate datetime 8      
EntryDate datetime 8      
Synched bit 1      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
DistCode pDistCode 6      
GLAcctSales pGlAcct 255      
GLAcctCOGS pGlAcct 255      
GLAcctInv pGlAcct 255      
GLAcctDiscount pGlAcct 255      
GLAcctCoupon pGlAcct 255      
GLAcctLayaway pGlAcct 255      
GLAcctRounding pGlAcct 255      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
ReplaceID bigint 8      
Description pDescription 255      
Order smallint 2      
HideYn bit 1      
Param nvarchar 255      
PluginName nvarchar 255      
AssemblyName nvarchar 255      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
Type tinyint 1   Contact Type 0 = SoldTo, 1 = BillTo, 2 = ShipTo
Name nvarchar 30      
Contact nvarchar 25      
Attn nvarchar 30      
Address1 nvarchar 30      
Address2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
Phone nvarchar 15      
Fax nvarchar 15      
Email pEmail 255      
Internet pWeb 255      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
ParentID bigint 8      
EntryNum int 4      
LineSeq int 4      
LineType smallint 2   Line Type 1 = Line Item, 2 = Tax, 3 = Freight, 4 = Misc, 5 = Reward Accrual, -1 = Payment, -2 = Coupon, -3 = Discount, -4 = Rounding Adjustment, -5 = Reward Redemption
ItemID pItemID 24      
LocID pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
Descr pDescription 255      
TaxClass tinyint 1      
Qty pDecimal 13      
Unit pUom 5      
ExtPrice pDecimal 13      
TaxAmount pDecimal 13      
PromoID nvarchar 10      
SalesRepID pSalesRep 3      
GLAcct pGlAcct 255      
GLAcctCOGS pGlAcct 255      
GLAcctInv pGlAcct 255      
Notes nvarchar max      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
DetailID bigint 8      
EntryDate datetime 8      
ExtCost pDecimal 13      
QtySeqNum_Cmtd int 4      
QtySeqNum int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
PostRun pPostRun 14      
TransIDPrefix nvarchar 7      
TransID int 4      
TransType smallint 2   Transaction Type 1 = Invoice, 2 = Quote, 10 = Layaway, -1 = Return
TransDate datetime 8      
RewardNumber nvarchar 255      
SoldToID pCustID 10      
BillToID pCustID 10      
ShipToID pCustID 10      
ShipVia nvarchar 20      
ShipNum nvarchar 18      
TaxableYN bit 1      
TaxExemptID nvarchar 255      
TaxGroupID pTaxLoc 10      
CurrencyID pCurrency 6      
SalesRepID pSalesRep 3      
DueDate datetime 8      
VoidDate datetime 8      
UserID bigint 8      
HostID pWrkStnID 20      
EntryDate datetime 8      
SourceId uniqueidentifier 16      
LocID pLocID 10      
DistCode pDistCode 6      
GLAcctReceivables pGlAcct 255      
Notes nvarchar max      
CF xml -1      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
PostRun pPostRun 14      
HeaderID bigint 8      
PmtDate datetime 8      
CustID pCustID 10      
PmtType tinyint 1   Payment Type 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit
PmtMethodID nvarchar 10      
CcNum nvarchar 255      
CcHolder nvarchar 30      
CcExpire datetime 8      
CcAuth nvarchar 10      
CcRef nvarchar 255      
CheckNum pCheckNum 10      
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nvarchar 255      
Amount pDecimal 13      
AmountBase pDecimal 13      
CurrencyID pCurrency 6      
VoidDate datetime 8      
UserID bigint 8      
HostID pWrkStnID 20      
EntryDate datetime 8      
LocID pLocID 10      
DistCode pDistCode 6      
GLAcctCash pGlAcct 255      
GLAcct pGlAcct 255      
Response nvarchar max      
Notes nvarchar max      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1      
TaxLevel tinyint 1      
TaxAmt pDecimal 13      
Taxable pDecimal 13      
NonTaxable pDecimal 13      
GLAcctLiability pGlAcct 255      
CF xml -1      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
PmtDate datetime 8      
CustID pCustID 10      
PmtType tinyint 1   Payment Type 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit
PmtMethodID nvarchar 10      
CcNum nvarchar 255      
CcHolder nvarchar 30      
CcExpire datetime 8      
CcAuth nvarchar 10      
CcRef nvarchar 255      
CheckNum pCheckNum 10      
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nvarchar 255      
Amount pDecimal 13      
AmountBase pDecimal 13      
CurrencyID pCurrency 6      
PostedYN bit 1      
VoidDate datetime 8      
UserID bigint 8      
HostID pWrkStnID 20      
EntryDate datetime 8      
Synched bit 1      
Settled bit 1      
Response nvarchar max      
Notes nvarchar max      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
RewardNumber nvarchar 255      
Status tinyint 1   Reward Account Status 0 = Active, 1 = Inactive
Type tinyint 1   Reward Account Type 0 = Regular
Level tinyint 1   Reward Account Level 0 = Regular
EnrollmentDate datetime 8      
Name nvarchar 30      
Address1 nvarchar 30      
Address2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
Phone nvarchar 15      
Fax nvarchar 15      
Email pEmail 255      
Internet pWeb 255      
Synched bit 1      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
ProgramID bigint 8      
AccountID bigint 8      
Type tinyint 1   Reward Activity Type 0 = Accrual, 1 = Adjustment, 2 = Redemption
TransDate datetime 8      
EntryDate datetime 8      
PointQty pDecimal 13      
PointValue pDecimal 13      
ActivityGroup pPostRun 14      
PostRun pPostRun 14      
PostDate datetime 8      
FiscalYear smallint 2      
FiscalPeriod smallint 2      
LiabilityAccount pGlAcct 255      
GLAccount pGlAcct 255      
Synched bit 1      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
Description pDescription 255      
Status tinyint 1   Reward Program Status 0 = Active, 1 = Inactive
Type tinyint 1   Reward Program Type 0 = Points Per Unit, 1 = Points Per Dollar
Prompt tinyint 1   Reward Program Prompt 0 = None, 1 = Confirm Address, 2 = Show Balance
StartDate datetime 8      
EndDate datetime 8      
PointAccrualRate pDecimal 13      
PointValue pDecimal 13      
LiabilityAccount pGlAcct 255      
ExpenseAccount pGlAcct 255      
RedemptionRate pDecimal 13      
Synched bit 1      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
Description pDescription 255      
Type tinyint 1   Tender Type 0 = Cash, 1 = Check, 2 = Coupon, 3 = Credit Card, 4 = Other
Value pDecimal 13      
CurrencyID pCurrency 6      
PmtMethodID nvarchar 10      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
Type tinyint 1   Contact Type 0 = Sold To, 1 = Bill To, 2 = Ship To
Name nvarchar 30      
Contact nvarchar 25      
Attn nvarchar 30      
Address1 nvarchar 30      
Address2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
Phone nvarchar 15      
Fax nvarchar 15      
Email pEmail 255      
Internet pWeb 255      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
ParentID bigint 8      
EntryNum int 4      
LineSeq int 4      
LineType smallint 2   Line Type 1 = Line Item, 2 = Tax, 3 = Freight, 4 = Misc, 5 = Reward Accrual, -1 = Payment, -2 = Coupon, -3 = Discount, -4 = Rounding Adjustment, -5 = Reward Redemption
ItemID pItemID 24      
LocID pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
Descr pDescription 255      
TaxClass tinyint 1      
Qty pDecimal 13      
Unit pUom 5      
ExtPrice pDecimal 13      
TaxAmount pDecimal 13      
PromoID nvarchar 10      
SalesRepID pSalesRep 3      
Notes nvarchar max      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
DetailID bigint 8      
EntryDate datetime 8      
ExtCost pDecimal 13      
QtySeqNum Cmtd 4      
QtySeqNum int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
TransIDPrefix nvarchar 7      
TransID int 4      
TransType smallint 2   Transaction Type 1 = Invoice, 2 = Quote, 10 = Layaway, -1 = Return
TransDate datetime 8      
RewardNumber nvarchar 255      
SoldToID pCustID 10      
BillToID pCustID 10      
ShipToID pCustID 10      
ShipVia nvarchar 20      
ShipNum nvarchar 18      
TaxableYN bit 1      
TaxExemptID nvarchar 255      
TaxGroupID pTaxLoc 10      
CurrencyID pCurrency 6      
SalesRepID pSalesRep 3      
DueDate datetime 8      
VoidDate datetime 8      
SuspendDate datetime 8      
UserID bigint 8      
HostID pWrkStnID 20      
EntryDate datetime 8      
Synched bit 1      
SourceId uniqueidentifier 16      
Notes nvarchar max      
ts timestamp 8      
CF xml -1      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
HostID pWrkStnID 20      
NextID int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1      
TaxLevel tinyint 1      
TaxAmt pDec 13      
Taxable pDec 13      
NonTaxable pDec 13      
ts timestamp 8      
CF xml -1      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct     Comment: PS Trans Tax does not need to include GL Accounts  
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
UserName pUserID 20      
Password nvarchar max      
EmployeeID pEmpID 11      
SalesRepID pSalesRep 3      
HostID pWrkStnID 20      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
UserID bigint 8      
HostID pWrkStnID 20      
FeatureID bigint 8      
ts timestamp 8      
CF xml -1